SELECT *, CASE WHEN `name` LIKE "rapid city%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "rapid city" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "rapid city" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "rapid city" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "SD" AND (locality IN ("rapid city") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 46
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "SD" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 46
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$3,450,0005550 Villaggio LnRapid City SD 57702View Listing
$2,950,00023910 Sun Country LnRapid City SD 57702View Listing
$2,900,00024060 Cosmos RdRapid City SD 57702View Listing
$2,395,0006185 Magic Canyon RdRapid City SD 57702View Listing
$1,975,0001128 Flormann StRapid City SD 57701View Listing
$1,749,9005018 Carriage Hills DrRapid City SD 57702View Listing
$1,675,0004280 Skyline Ranch CtRapid City SD 57701View Listing
$1,600,0004101 Parkridge PlRapid City SD 57702View Listing
$1,590,00011845 N Haines AveRapid City SD 57701View Listing
$1,450,00010930 W Highway 44Rapid City SD 57702View Listing
$1,415,0004461 Forest Park CtRapid City SD 57702View Listing
$1,400,000Covenant Dr Lot 10Rapid City SD 57702View Listing
$1,390,00013768 47th Ave WRapid City SD 57702View Listing
$1,349,0006720 Prestwick RdRapid City SD 57702View Listing
$1,295,00024160 Pine Grove RdRapid City SD 57702View Listing
$1,200,0005740 Cloud Peak DrRapid City SD 57702View Listing
$1,200,00013395 Woodcrest CtRapid City SD 57702View Listing
$1,175,0006025 Cloud Peak DrRapid City SD 57702View Listing
$1,125,00023663 Dogleg DrRapid City SD 57702View Listing
$1,095,0001003 West BlvdRapid City SD 57701View Listing
$995,0006712 Carnoustie CtRapid City SD 57702View Listing
$934,9005412 Cloud Peak DrRapid City SD 57702View Listing
$899,00023165 Justice LnRapid City SD 57703View Listing
$899,00023165 OtherRapid City SD 57703View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 3:14:18 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "SD" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 46
Blah